CREATE EXTERNAL TABLE `jms_dwd`.`dwd_tab_barscan_sign_realtime_flink_dt`(
`waybillid` string COMMENT '单号',
 `scannetworkcode` string COMMENT '扫描网点编码',
 `scantime` string COMMENT '签收时间',
 `signname` string COMMENT '签收类型名称',
 `deliveryname` string COMMENT '派件员名称',
 `deliverycode` string COMMENT '派件员编码',
 `sendsigntype` string COMMENT '上门签收类型',
 `nonstandardsitetype` string COMMENT '非标准代收点签收类型',
 `transferorder` string COMMENT '是否中转单,0否,1是',
 `sendsigntypename` string COMMENT '签收类型名称',
 `labeltype` string COMMENT '送货上门,代收点')
PARTITIONED BY (`dt` string COMMENT '签收时间scanTime（yyyy-MM-dd）')
stored as parquet
LOCATION 'hdfs://yl-bg-hdp/dw/hive/jms_dwd.db/external/dwd_tab_barscan_sign_realtime_flink_dt'